﻿CREATE TABLE [dbo].[Person] (
    [Id]             UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [FirstName]      NVARCHAR (100)   NOT NULL,
    [OtherNames]     NVARCHAR (250)   NOT NULL,
    [PhotoLocation]  NVARCHAR (250)   NULL,
    [SignatureImage] IMAGE            NULL,
    [OfficialEmail]  NVARCHAR (50)    NULL,
    [OfficialPhone]  NVARCHAR (60)    NULL,
    [IDNo]           NVARCHAR (50)    NULL
);

